create external table jms_dm.dm_center_stop_time_detail_dt
(
    date_time  date COMMENT '日期',
    waybill_no string COMMENT '运单号',
    send_shipment_no string COMMENT 't任务单',
    center_name string COMMENT 't中心名称',
    center_name_code string COMMENT 't中心编码',
    center_arrival_time timestamp COMMENT 't中心到达时间',
    center_send_time timestamp COMMENT 't中心发件时间',
    center_last_time timestamp COMMENT 't中心发车时间',
    send_next_name string COMMENT 't下一站名称',
    next_type string COMMENT 't下一站是否为中心',
    diff_time decimal(10,4) COMMENT 't停留时间',
    invalid_type string COMMENT '无效类型',
    stop_type bigint COMMENT '明细类型'
)
COMMENT '中心停留时长取数,48'
PARTITIONED BY ( dt string COMMENT '时间分区')
stored as parquet
LOCATION '/dw/hive/jms_dm.db/external/dm_center_stop_time_detail_dt'
TBLPROPERTIES (     'discover.partitions' = 'false',  'parquet.column.index.access' = 'true');


 ALTER TABLE jms_dm.dm_center_stop_time_detail_dt ADD COLUMN agent_name varchar(100)  COMMENT '代理区';
 ALTER TABLE jms_dm.dm_center_stop_time_detail_dt ADD COLUMN agent_code varchar(100)  COMMENT '代理区code';
